Release 10.1A: OpenEdge Data Management:
SQL Reference

DROP INDEX

Deletes an index on the specified table.

Syntax

DROP INDEX [ index_owner_name.]index_name ON [ table_owner_name.]table_name ;

index_owner_name

Specifies the name of the index owner. If index_owner_name is specified and is different from the name of the user executing the statement, then the user must have DBA privileges.

table_name

Verifies the index_name to correspond to the table.

Note

You cannot drop the first index created on a table, except by dropping the table.

Example

DROP INDEX custindex ON customer;

Authorization

Must have DBA privilege or ownership of the index.

Related statements

CREATE INDEX